set hive.exec.dynamic.partition=true;--动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=20;--每天生成 20 个分区
set hive.exec.max.dynamic.partitions.pernode=20;--每天生成 20 个分区
insert overwrite table jms_dim.dim_yl_nwm_business_indicators
select
 ID
,NETWORK_CODE
,NETWORK_NAME
,PROXY_CODE
,PROXY_NAME
,AREA_INFO_CODE
,AREA_INFO_NAME
,TOP_AREA_INFO_CODE
,TOP_AREA_INFO_NAME
,TARGET_COMPLETION
,CREATE_BY
,UPdate_BY
,CREATE_BY_NAME
,UPdate_BY_NAME
,TARGET_MONTH
,CREATE_TIME
,UPdate_TIME
,CREATE_CODE
,UPdate_CODE
from jms_ods.yl_nwm_business_indicators where dt= '{{ execution_date | cst_ds }}'
distribute by 1 ;